Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 21

How can you show or hide the gridlines in Excel Worksheet?

a) Go to Tools >> Options > > View tab and mark or remove the check box named Gridline

b) Click Gridline tool on Forms toolbar

c) Both of above

d) Press F7

e) None of these

Question : 22

The divide symbol is

a) /

b) D

c) \

d) )

e) None of these

Question : 23

When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as

a) AutoFill

b) AutoCorrect

c) AutoComplete

d) AutoFormat

e) None of these

Question : 24

In a worksheet you can select

a) The entire worksheet

b) Rows

c) Columns

d) All of the above

e) None of these

Question : 25

How should you print a selected area of a worksheet, if you'll want to print a different area next time?

a) On the file menu, point to print area, and then click set print area.

b) On the file menu, click print, and then click selection under print what

c) On the view menu, click custom views, then click add

d) All of above

e) None of these